package com.fable.dal.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ClueQuery {
    /**
     * order by clause.
     */
    protected String orderByClause;

    /**
     * distinct
     */
    protected boolean distinct;

    /**
     * criteria list
     */
    protected List<Criteria> oredCriteria;

    /**
     * page
     */
    protected Integer pageOffset;

    /**
     * page size
     */
    protected Integer pageSize;

    public ClueQuery() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public boolean isValid() {
        for (int i = 0; i < oredCriteria.size(); i++) {
            if (oredCriteria.get(i).isValid()) {
                return true;
            }
        }
        return false;
    }

    public void setPageOffset(Integer pageOffset) {
        this.pageOffset = pageOffset;
    }

    public Integer getPageOffset() {
        return pageOffset;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize = pageSize;
    }

    public Integer getPageSize() {
        return pageSize;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }
        /**

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }


                public Criteria andGmtCreateIsNull() {
                    addCriterion("gmt_create is null");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateIsNotNull() {
                    addCriterion("gmt_create is not null");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateEqualTo(Date value) {
                    addCriterion("gmt_create =", value, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateNotEqualTo(Date value) {
                    addCriterion("gmt_create <>", value, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateGreaterThan(Date value) {
                    addCriterion("gmt_create >", value, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateGreaterThanOrEqualTo(Date value) {
                    addCriterion("gmt_create >=", value, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateLessThan(Date value) {
                    addCriterion("gmt_create <", value, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateLessThanOrEqualTo(Date value) {
                    addCriterion("gmt_create <=", value, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateIn(List<Date> values) {
                    addCriterion("gmt_create in", values, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateNotIn(List<Date> values) {
                    addCriterion("gmt_create not in", values, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateBetween(Date value1, Date value2) {
                    addCriterion("gmt_create between", value1, value2, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtCreateNotBetween(Date value1, Date value2) {
                    addCriterion("gmt_create not between", value1, value2, "gmtCreate");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedIsNull() {
                    addCriterion("gmt_modified is null");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedIsNotNull() {
                    addCriterion("gmt_modified is not null");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedEqualTo(Date value) {
                    addCriterion("gmt_modified =", value, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedNotEqualTo(Date value) {
                    addCriterion("gmt_modified <>", value, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedGreaterThan(Date value) {
                    addCriterion("gmt_modified >", value, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedGreaterThanOrEqualTo(Date value) {
                    addCriterion("gmt_modified >=", value, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedLessThan(Date value) {
                    addCriterion("gmt_modified <", value, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedLessThanOrEqualTo(Date value) {
                    addCriterion("gmt_modified <=", value, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedIn(List<Date> values) {
                    addCriterion("gmt_modified in", values, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedNotIn(List<Date> values) {
                    addCriterion("gmt_modified not in", values, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedBetween(Date value1, Date value2) {
                    addCriterion("gmt_modified between", value1, value2, "gmtModified");
                    return (Criteria) this;
                }

                public Criteria andGmtModifiedNotBetween(Date value1, Date value2) {
                    addCriterion("gmt_modified not between", value1, value2, "gmtModified");
                    return (Criteria) this;
                }
                 **/

        public Criteria andClueIdIsNull() {
            addCriterion("clue_id is null");
            return (Criteria) this;
        }

        public Criteria andClueIdIsNotNull() {
            addCriterion("clue_id is not null");
            return (Criteria) this;
        }

        public Criteria andClueIdEqualTo(Long value) {
            addCriterion("clue_id =", value, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdNotEqualTo(Long value) {
            addCriterion("clue_id <>", value, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdGreaterThan(Long value) {
            addCriterion("clue_id >", value, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdGreaterThanOrEqualTo(Long value) {
            addCriterion("clue_id >=", value, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdLessThan(Long value) {
            addCriterion("clue_id <", value, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdLessThanOrEqualTo(Long value) {
            addCriterion("clue_id <=", value, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdLike(Long value) {
            addCriterion("clue_id like", value, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdNotLike(Long value) {
            addCriterion("clue_id not like", value, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdIn(List<Long> values) {
            addCriterion("clue_id in", values, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdNotIn(List<Long> values) {
            addCriterion("clue_id not in", values, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdBetween(Long value1, Long value2) {
            addCriterion("clue_id between", value1, value2, "clueId");
            return (Criteria) this;
        }

        public Criteria andClueIdNotBetween(Long value1, Long value2) {
            addCriterion("clue_id not between", value1, value2, "clueId");
            return (Criteria) this;
        }

        public Criteria andAgentIdIsNull() {
            addCriterion("agent_id is null");
            return (Criteria) this;
        }

        public Criteria andAgentIdIsNotNull() {
            addCriterion("agent_id is not null");
            return (Criteria) this;
        }

        public Criteria andAgentIdEqualTo(Long value) {
            addCriterion("agent_id =", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotEqualTo(Long value) {
            addCriterion("agent_id <>", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdGreaterThan(Long value) {
            addCriterion("agent_id >", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdGreaterThanOrEqualTo(Long value) {
            addCriterion("agent_id >=", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLessThan(Long value) {
            addCriterion("agent_id <", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLessThanOrEqualTo(Long value) {
            addCriterion("agent_id <=", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLike(Long value) {
            addCriterion("agent_id like", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotLike(Long value) {
            addCriterion("agent_id not like", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdIn(List<Long> values) {
            addCriterion("agent_id in", values, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotIn(List<Long> values) {
            addCriterion("agent_id not in", values, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdBetween(Long value1, Long value2) {
            addCriterion("agent_id between", value1, value2, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotBetween(Long value1, Long value2) {
            addCriterion("agent_id not between", value1, value2, "agentId");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andRealNameIsNull() {
            addCriterion("real_name is null");
            return (Criteria) this;
        }

        public Criteria andRealNameIsNotNull() {
            addCriterion("real_name is not null");
            return (Criteria) this;
        }

        public Criteria andRealNameEqualTo(String value) {
            addCriterion("real_name =", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotEqualTo(String value) {
            addCriterion("real_name <>", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameGreaterThan(String value) {
            addCriterion("real_name >", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameGreaterThanOrEqualTo(String value) {
            addCriterion("real_name >=", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLessThan(String value) {
            addCriterion("real_name <", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLessThanOrEqualTo(String value) {
            addCriterion("real_name <=", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLike(String value) {
            addCriterion("real_name like", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotLike(String value) {
            addCriterion("real_name not like", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameIn(List<String> values) {
            addCriterion("real_name in", values, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotIn(List<String> values) {
            addCriterion("real_name not in", values, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameBetween(String value1, String value2) {
            addCriterion("real_name between", value1, value2, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotBetween(String value1, String value2) {
            addCriterion("real_name not between", value1, value2, "realName");
            return (Criteria) this;
        }

        public Criteria andLevelIsNull() {
            addCriterion("level is null");
            return (Criteria) this;
        }

        public Criteria andLevelIsNotNull() {
            addCriterion("level is not null");
            return (Criteria) this;
        }

        public Criteria andLevelEqualTo(Integer value) {
            addCriterion("level =", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotEqualTo(Integer value) {
            addCriterion("level <>", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelGreaterThan(Integer value) {
            addCriterion("level >", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("level >=", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelLessThan(Integer value) {
            addCriterion("level <", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelLessThanOrEqualTo(Integer value) {
            addCriterion("level <=", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelLike(Integer value) {
            addCriterion("level like", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotLike(Integer value) {
            addCriterion("level not like", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelIn(List<Integer> values) {
            addCriterion("level in", values, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotIn(List<Integer> values) {
            addCriterion("level not in", values, "level");
            return (Criteria) this;
        }

        public Criteria andLevelBetween(Integer value1, Integer value2) {
            addCriterion("level between", value1, value2, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("level not between", value1, value2, "level");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("source like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("source not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andBuyerNameIsNull() {
            addCriterion("buyer_name is null");
            return (Criteria) this;
        }

        public Criteria andBuyerNameIsNotNull() {
            addCriterion("buyer_name is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerNameEqualTo(String value) {
            addCriterion("buyer_name =", value, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameNotEqualTo(String value) {
            addCriterion("buyer_name <>", value, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameGreaterThan(String value) {
            addCriterion("buyer_name >", value, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameGreaterThanOrEqualTo(String value) {
            addCriterion("buyer_name >=", value, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameLessThan(String value) {
            addCriterion("buyer_name <", value, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameLessThanOrEqualTo(String value) {
            addCriterion("buyer_name <=", value, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameLike(String value) {
            addCriterion("buyer_name like", value, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameNotLike(String value) {
            addCriterion("buyer_name not like", value, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameIn(List<String> values) {
            addCriterion("buyer_name in", values, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameNotIn(List<String> values) {
            addCriterion("buyer_name not in", values, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameBetween(String value1, String value2) {
            addCriterion("buyer_name between", value1, value2, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerNameNotBetween(String value1, String value2) {
            addCriterion("buyer_name not between", value1, value2, "buyerName");
            return (Criteria) this;
        }

        public Criteria andBuyerSexIsNull() {
            addCriterion("buyer_sex is null");
            return (Criteria) this;
        }

        public Criteria andBuyerSexIsNotNull() {
            addCriterion("buyer_sex is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerSexEqualTo(Integer value) {
            addCriterion("buyer_sex =", value, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexNotEqualTo(Integer value) {
            addCriterion("buyer_sex <>", value, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexGreaterThan(Integer value) {
            addCriterion("buyer_sex >", value, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("buyer_sex >=", value, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexLessThan(Integer value) {
            addCriterion("buyer_sex <", value, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexLessThanOrEqualTo(Integer value) {
            addCriterion("buyer_sex <=", value, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexLike(Integer value) {
            addCriterion("buyer_sex like", value, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexNotLike(Integer value) {
            addCriterion("buyer_sex not like", value, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexIn(List<Integer> values) {
            addCriterion("buyer_sex in", values, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexNotIn(List<Integer> values) {
            addCriterion("buyer_sex not in", values, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexBetween(Integer value1, Integer value2) {
            addCriterion("buyer_sex between", value1, value2, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerSexNotBetween(Integer value1, Integer value2) {
            addCriterion("buyer_sex not between", value1, value2, "buyerSex");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameIsNull() {
            addCriterion("buyer_province_name is null");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameIsNotNull() {
            addCriterion("buyer_province_name is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameEqualTo(String value) {
            addCriterion("buyer_province_name =", value, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameNotEqualTo(String value) {
            addCriterion("buyer_province_name <>", value, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameGreaterThan(String value) {
            addCriterion("buyer_province_name >", value, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameGreaterThanOrEqualTo(String value) {
            addCriterion("buyer_province_name >=", value, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameLessThan(String value) {
            addCriterion("buyer_province_name <", value, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameLessThanOrEqualTo(String value) {
            addCriterion("buyer_province_name <=", value, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameLike(String value) {
            addCriterion("buyer_province_name like", value, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameNotLike(String value) {
            addCriterion("buyer_province_name not like", value, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameIn(List<String> values) {
            addCriterion("buyer_province_name in", values, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameNotIn(List<String> values) {
            addCriterion("buyer_province_name not in", values, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameBetween(String value1, String value2) {
            addCriterion("buyer_province_name between", value1, value2, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerProvinceNameNotBetween(String value1, String value2) {
            addCriterion("buyer_province_name not between", value1, value2, "buyerProvinceName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameIsNull() {
            addCriterion("buyer_city_name is null");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameIsNotNull() {
            addCriterion("buyer_city_name is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameEqualTo(String value) {
            addCriterion("buyer_city_name =", value, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameNotEqualTo(String value) {
            addCriterion("buyer_city_name <>", value, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameGreaterThan(String value) {
            addCriterion("buyer_city_name >", value, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("buyer_city_name >=", value, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameLessThan(String value) {
            addCriterion("buyer_city_name <", value, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameLessThanOrEqualTo(String value) {
            addCriterion("buyer_city_name <=", value, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameLike(String value) {
            addCriterion("buyer_city_name like", value, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameNotLike(String value) {
            addCriterion("buyer_city_name not like", value, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameIn(List<String> values) {
            addCriterion("buyer_city_name in", values, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameNotIn(List<String> values) {
            addCriterion("buyer_city_name not in", values, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameBetween(String value1, String value2) {
            addCriterion("buyer_city_name between", value1, value2, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerCityNameNotBetween(String value1, String value2) {
            addCriterion("buyer_city_name not between", value1, value2, "buyerCityName");
            return (Criteria) this;
        }

        public Criteria andBuyerContactIsNull() {
            addCriterion("buyer_contact is null");
            return (Criteria) this;
        }

        public Criteria andBuyerContactIsNotNull() {
            addCriterion("buyer_contact is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerContactEqualTo(String value) {
            addCriterion("buyer_contact =", value, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactNotEqualTo(String value) {
            addCriterion("buyer_contact <>", value, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactGreaterThan(String value) {
            addCriterion("buyer_contact >", value, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactGreaterThanOrEqualTo(String value) {
            addCriterion("buyer_contact >=", value, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactLessThan(String value) {
            addCriterion("buyer_contact <", value, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactLessThanOrEqualTo(String value) {
            addCriterion("buyer_contact <=", value, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactLike(String value) {
            addCriterion("buyer_contact like", value, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactNotLike(String value) {
            addCriterion("buyer_contact not like", value, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactIn(List<String> values) {
            addCriterion("buyer_contact in", values, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactNotIn(List<String> values) {
            addCriterion("buyer_contact not in", values, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactBetween(String value1, String value2) {
            addCriterion("buyer_contact between", value1, value2, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andBuyerContactNotBetween(String value1, String value2) {
            addCriterion("buyer_contact not between", value1, value2, "buyerContact");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusIsNull() {
            addCriterion("effective_status is null");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusIsNotNull() {
            addCriterion("effective_status is not null");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusEqualTo(Integer value) {
            addCriterion("effective_status =", value, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusNotEqualTo(Integer value) {
            addCriterion("effective_status <>", value, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusGreaterThan(Integer value) {
            addCriterion("effective_status >", value, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("effective_status >=", value, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusLessThan(Integer value) {
            addCriterion("effective_status <", value, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusLessThanOrEqualTo(Integer value) {
            addCriterion("effective_status <=", value, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusLike(Integer value) {
            addCriterion("effective_status like", value, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusNotLike(Integer value) {
            addCriterion("effective_status not like", value, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusIn(List<Integer> values) {
            addCriterion("effective_status in", values, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusNotIn(List<Integer> values) {
            addCriterion("effective_status not in", values, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusBetween(Integer value1, Integer value2) {
            addCriterion("effective_status between", value1, value2, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andEffectiveStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("effective_status not between", value1, value2, "effectiveStatus");
            return (Criteria) this;
        }

        public Criteria andTargetCarIsNull() {
            addCriterion("target_car is null");
            return (Criteria) this;
        }

        public Criteria andTargetCarIsNotNull() {
            addCriterion("target_car is not null");
            return (Criteria) this;
        }

        public Criteria andTargetCarEqualTo(String value) {
            addCriterion("target_car =", value, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarNotEqualTo(String value) {
            addCriterion("target_car <>", value, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarGreaterThan(String value) {
            addCriterion("target_car >", value, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarGreaterThanOrEqualTo(String value) {
            addCriterion("target_car >=", value, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarLessThan(String value) {
            addCriterion("target_car <", value, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarLessThanOrEqualTo(String value) {
            addCriterion("target_car <=", value, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarLike(String value) {
            addCriterion("target_car like", value, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarNotLike(String value) {
            addCriterion("target_car not like", value, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarIn(List<String> values) {
            addCriterion("target_car in", values, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarNotIn(List<String> values) {
            addCriterion("target_car not in", values, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarBetween(String value1, String value2) {
            addCriterion("target_car between", value1, value2, "targetCar");
            return (Criteria) this;
        }

        public Criteria andTargetCarNotBetween(String value1, String value2) {
            addCriterion("target_car not between", value1, value2, "targetCar");
            return (Criteria) this;
        }

        public Criteria andOtherTargetIsNull() {
            addCriterion("other_target is null");
            return (Criteria) this;
        }

        public Criteria andOtherTargetIsNotNull() {
            addCriterion("other_target is not null");
            return (Criteria) this;
        }

        public Criteria andOtherTargetEqualTo(String value) {
            addCriterion("other_target =", value, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetNotEqualTo(String value) {
            addCriterion("other_target <>", value, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetGreaterThan(String value) {
            addCriterion("other_target >", value, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetGreaterThanOrEqualTo(String value) {
            addCriterion("other_target >=", value, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetLessThan(String value) {
            addCriterion("other_target <", value, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetLessThanOrEqualTo(String value) {
            addCriterion("other_target <=", value, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetLike(String value) {
            addCriterion("other_target like", value, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetNotLike(String value) {
            addCriterion("other_target not like", value, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetIn(List<String> values) {
            addCriterion("other_target in", values, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetNotIn(List<String> values) {
            addCriterion("other_target not in", values, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetBetween(String value1, String value2) {
            addCriterion("other_target between", value1, value2, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andOtherTargetNotBetween(String value1, String value2) {
            addCriterion("other_target not between", value1, value2, "otherTarget");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameIsNull() {
            addCriterion("create_user_name is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameIsNotNull() {
            addCriterion("create_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameEqualTo(String value) {
            addCriterion("create_user_name =", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameNotEqualTo(String value) {
            addCriterion("create_user_name <>", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameGreaterThan(String value) {
            addCriterion("create_user_name >", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("create_user_name >=", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameLessThan(String value) {
            addCriterion("create_user_name <", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameLessThanOrEqualTo(String value) {
            addCriterion("create_user_name <=", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameLike(String value) {
            addCriterion("create_user_name like", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameNotLike(String value) {
            addCriterion("create_user_name not like", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameIn(List<String> values) {
            addCriterion("create_user_name in", values, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameNotIn(List<String> values) {
            addCriterion("create_user_name not in", values, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameBetween(String value1, String value2) {
            addCriterion("create_user_name between", value1, value2, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameNotBetween(String value1, String value2) {
            addCriterion("create_user_name not between", value1, value2, "createUserName");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdIsNull() {
            addCriterion("process_user_id is null");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdIsNotNull() {
            addCriterion("process_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdEqualTo(Long value) {
            addCriterion("process_user_id =", value, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdNotEqualTo(Long value) {
            addCriterion("process_user_id <>", value, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdGreaterThan(Long value) {
            addCriterion("process_user_id >", value, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("process_user_id >=", value, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdLessThan(Long value) {
            addCriterion("process_user_id <", value, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdLessThanOrEqualTo(Long value) {
            addCriterion("process_user_id <=", value, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdLike(Long value) {
            addCriterion("process_user_id like", value, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdNotLike(Long value) {
            addCriterion("process_user_id not like", value, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdIn(List<Long> values) {
            addCriterion("process_user_id in", values, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdNotIn(List<Long> values) {
            addCriterion("process_user_id not in", values, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdBetween(Long value1, Long value2) {
            addCriterion("process_user_id between", value1, value2, "processUserId");
            return (Criteria) this;
        }

        public Criteria andProcessUserIdNotBetween(Long value1, Long value2) {
            addCriterion("process_user_id not between", value1, value2, "processUserId");
            return (Criteria) this;
        }

        public Criteria andClueImgIsNull() {
            addCriterion("clue_img is null");
            return (Criteria) this;
        }

        public Criteria andClueImgIsNotNull() {
            addCriterion("clue_img is not null");
            return (Criteria) this;
        }

        public Criteria andClueImgEqualTo(String value) {
            addCriterion("clue_img =", value, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgNotEqualTo(String value) {
            addCriterion("clue_img <>", value, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgGreaterThan(String value) {
            addCriterion("clue_img >", value, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgGreaterThanOrEqualTo(String value) {
            addCriterion("clue_img >=", value, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgLessThan(String value) {
            addCriterion("clue_img <", value, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgLessThanOrEqualTo(String value) {
            addCriterion("clue_img <=", value, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgLike(String value) {
            addCriterion("clue_img like", value, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgNotLike(String value) {
            addCriterion("clue_img not like", value, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgIn(List<String> values) {
            addCriterion("clue_img in", values, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgNotIn(List<String> values) {
            addCriterion("clue_img not in", values, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgBetween(String value1, String value2) {
            addCriterion("clue_img between", value1, value2, "clueImg");
            return (Criteria) this;
        }

        public Criteria andClueImgNotBetween(String value1, String value2) {
            addCriterion("clue_img not between", value1, value2, "clueImg");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(Date value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(Date value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(Date value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(Date value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(Date value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLike(Date value) {
            addCriterion("gmt_create like", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotLike(Date value) {
            addCriterion("gmt_create not like", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<Date> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<Date> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(Date value1, Date value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(Date value1, Date value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(Date value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(Date value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(Date value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(Date value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(Date value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLike(Date value) {
            addCriterion("gmt_modified like", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotLike(Date value) {
            addCriterion("gmt_modified not like", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<Date> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<Date> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(Date value1, Date value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(Date value1, Date value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andActionTypeIsNull() {
            addCriterion("action_type is null");
            return (Criteria) this;
        }

        public Criteria andActionTypeIsNotNull() {
            addCriterion("action_type is not null");
            return (Criteria) this;
        }

        public Criteria andActionTypeEqualTo(Integer value) {
            addCriterion("action_type =", value, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeNotEqualTo(Integer value) {
            addCriterion("action_type <>", value, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeGreaterThan(Integer value) {
            addCriterion("action_type >", value, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("action_type >=", value, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeLessThan(Integer value) {
            addCriterion("action_type <", value, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeLessThanOrEqualTo(Integer value) {
            addCriterion("action_type <=", value, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeLike(Integer value) {
            addCriterion("action_type like", value, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeNotLike(Integer value) {
            addCriterion("action_type not like", value, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeIn(List<Integer> values) {
            addCriterion("action_type in", values, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeNotIn(List<Integer> values) {
            addCriterion("action_type not in", values, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeBetween(Integer value1, Integer value2) {
            addCriterion("action_type between", value1, value2, "actionType");
            return (Criteria) this;
        }

        public Criteria andActionTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("action_type not between", value1, value2, "actionType");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdIsNull() {
            addCriterion("exchange_user_id is null");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdIsNotNull() {
            addCriterion("exchange_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdEqualTo(Long value) {
            addCriterion("exchange_user_id =", value, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdNotEqualTo(Long value) {
            addCriterion("exchange_user_id <>", value, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdGreaterThan(Long value) {
            addCriterion("exchange_user_id >", value, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("exchange_user_id >=", value, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdLessThan(Long value) {
            addCriterion("exchange_user_id <", value, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdLessThanOrEqualTo(Long value) {
            addCriterion("exchange_user_id <=", value, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdLike(Long value) {
            addCriterion("exchange_user_id like", value, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdNotLike(Long value) {
            addCriterion("exchange_user_id not like", value, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdIn(List<Long> values) {
            addCriterion("exchange_user_id in", values, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdNotIn(List<Long> values) {
            addCriterion("exchange_user_id not in", values, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdBetween(Long value1, Long value2) {
            addCriterion("exchange_user_id between", value1, value2, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeUserIdNotBetween(Long value1, Long value2) {
            addCriterion("exchange_user_id not between", value1, value2, "exchangeUserId");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusIsNull() {
            addCriterion("exchange_status is null");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusIsNotNull() {
            addCriterion("exchange_status is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusEqualTo(Integer value) {
            addCriterion("exchange_status =", value, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusNotEqualTo(Integer value) {
            addCriterion("exchange_status <>", value, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusGreaterThan(Integer value) {
            addCriterion("exchange_status >", value, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("exchange_status >=", value, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusLessThan(Integer value) {
            addCriterion("exchange_status <", value, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusLessThanOrEqualTo(Integer value) {
            addCriterion("exchange_status <=", value, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusLike(Integer value) {
            addCriterion("exchange_status like", value, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusNotLike(Integer value) {
            addCriterion("exchange_status not like", value, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusIn(List<Integer> values) {
            addCriterion("exchange_status in", values, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusNotIn(List<Integer> values) {
            addCriterion("exchange_status not in", values, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusBetween(Integer value1, Integer value2) {
            addCriterion("exchange_status between", value1, value2, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andExchangeStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("exchange_status not between", value1, value2, "exchangeStatus");
            return (Criteria) this;
        }

        public Criteria andForecastDateIsNull() {
            addCriterion("forecast_date is null");
            return (Criteria) this;
        }

        public Criteria andForecastDateIsNotNull() {
            addCriterion("forecast_date is not null");
            return (Criteria) this;
        }

        public Criteria andForecastDateEqualTo(Date value) {
            addCriterion("forecast_date =", value, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateNotEqualTo(Date value) {
            addCriterion("forecast_date <>", value, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateGreaterThan(Date value) {
            addCriterion("forecast_date >", value, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateGreaterThanOrEqualTo(Date value) {
            addCriterion("forecast_date >=", value, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateLessThan(Date value) {
            addCriterion("forecast_date <", value, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateLessThanOrEqualTo(Date value) {
            addCriterion("forecast_date <=", value, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateLike(Date value) {
            addCriterion("forecast_date like", value, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateNotLike(Date value) {
            addCriterion("forecast_date not like", value, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateIn(List<Date> values) {
            addCriterion("forecast_date in", values, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateNotIn(List<Date> values) {
            addCriterion("forecast_date not in", values, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateBetween(Date value1, Date value2) {
            addCriterion("forecast_date between", value1, value2, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andForecastDateNotBetween(Date value1, Date value2) {
            addCriterion("forecast_date not between", value1, value2, "forecastDate");
            return (Criteria) this;
        }

        public Criteria andMhcdIsNull() {
            addCriterion("mhcd is null");
            return (Criteria) this;
        }

        public Criteria andMhcdIsNotNull() {
            addCriterion("mhcd is not null");
            return (Criteria) this;
        }

        public Criteria andMhcdEqualTo(String value) {
            addCriterion("mhcd =", value, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdNotEqualTo(String value) {
            addCriterion("mhcd <>", value, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdGreaterThan(String value) {
            addCriterion("mhcd >", value, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdGreaterThanOrEqualTo(String value) {
            addCriterion("mhcd >=", value, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdLessThan(String value) {
            addCriterion("mhcd <", value, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdLessThanOrEqualTo(String value) {
            addCriterion("mhcd <=", value, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdLike(String value) {
            addCriterion("mhcd like", value, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdNotLike(String value) {
            addCriterion("mhcd not like", value, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdIn(List<String> values) {
            addCriterion("mhcd in", values, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdNotIn(List<String> values) {
            addCriterion("mhcd not in", values, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdBetween(String value1, String value2) {
            addCriterion("mhcd between", value1, value2, "mhcd");
            return (Criteria) this;
        }

        public Criteria andMhcdNotBetween(String value1, String value2) {
            addCriterion("mhcd not between", value1, value2, "mhcd");
            return (Criteria) this;
        }

        public Criteria andDealerIdIsNull() {
            addCriterion("dealer_id is null");
            return (Criteria) this;
        }

        public Criteria andDealerIdIsNotNull() {
            addCriterion("dealer_id is not null");
            return (Criteria) this;
        }

        public Criteria andDealerIdEqualTo(Long value) {
            addCriterion("dealer_id =", value, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdNotEqualTo(Long value) {
            addCriterion("dealer_id <>", value, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdGreaterThan(Long value) {
            addCriterion("dealer_id >", value, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("dealer_id >=", value, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdLessThan(Long value) {
            addCriterion("dealer_id <", value, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdLessThanOrEqualTo(Long value) {
            addCriterion("dealer_id <=", value, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdLike(Long value) {
            addCriterion("dealer_id like", value, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdNotLike(Long value) {
            addCriterion("dealer_id not like", value, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdIn(List<Long> values) {
            addCriterion("dealer_id in", values, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdNotIn(List<Long> values) {
            addCriterion("dealer_id not in", values, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdBetween(Long value1, Long value2) {
            addCriterion("dealer_id between", value1, value2, "dealerId");
            return (Criteria) this;
        }

        public Criteria andDealerIdNotBetween(Long value1, Long value2) {
            addCriterion("dealer_id not between", value1, value2, "dealerId");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(Integer value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(Integer value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNull() {
            addCriterion("item_id is null");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNotNull() {
            addCriterion("item_id is not null");
            return (Criteria) this;
        }

        public Criteria andItemIdEqualTo(Long value) {
            addCriterion("item_id =", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotEqualTo(Long value) {
            addCriterion("item_id <>", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThan(Long value) {
            addCriterion("item_id >", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThanOrEqualTo(Long value) {
            addCriterion("item_id >=", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThan(Long value) {
            addCriterion("item_id <", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThanOrEqualTo(Long value) {
            addCriterion("item_id <=", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLike(Long value) {
            addCriterion("item_id like", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotLike(Long value) {
            addCriterion("item_id not like", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdIn(List<Long> values) {
            addCriterion("item_id in", values, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotIn(List<Long> values) {
            addCriterion("item_id not in", values, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdBetween(Long value1, Long value2) {
            addCriterion("item_id between", value1, value2, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotBetween(Long value1, Long value2) {
            addCriterion("item_id not between", value1, value2, "itemId");
            return (Criteria) this;
        }

        public Criteria andInvolvedIsNull() {
            addCriterion("involved is null");
            return (Criteria) this;
        }

        public Criteria andInvolvedIsNotNull() {
            addCriterion("involved is not null");
            return (Criteria) this;
        }

        public Criteria andInvolvedEqualTo(Integer value) {
            addCriterion("involved =", value, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedNotEqualTo(Integer value) {
            addCriterion("involved <>", value, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedGreaterThan(Integer value) {
            addCriterion("involved >", value, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedGreaterThanOrEqualTo(Integer value) {
            addCriterion("involved >=", value, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedLessThan(Integer value) {
            addCriterion("involved <", value, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedLessThanOrEqualTo(Integer value) {
            addCriterion("involved <=", value, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedLike(Integer value) {
            addCriterion("involved like", value, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedNotLike(Integer value) {
            addCriterion("involved not like", value, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedIn(List<Integer> values) {
            addCriterion("involved in", values, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedNotIn(List<Integer> values) {
            addCriterion("involved not in", values, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedBetween(Integer value1, Integer value2) {
            addCriterion("involved between", value1, value2, "involved");
            return (Criteria) this;
        }

        public Criteria andInvolvedNotBetween(Integer value1, Integer value2) {
            addCriterion("involved not between", value1, value2, "involved");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdIsNull() {
            addCriterion("agent_user_id is null");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdIsNotNull() {
            addCriterion("agent_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdEqualTo(Long value) {
            addCriterion("agent_user_id =", value, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdNotEqualTo(Long value) {
            addCriterion("agent_user_id <>", value, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdGreaterThan(Long value) {
            addCriterion("agent_user_id >", value, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("agent_user_id >=", value, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdLessThan(Long value) {
            addCriterion("agent_user_id <", value, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdLessThanOrEqualTo(Long value) {
            addCriterion("agent_user_id <=", value, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdLike(Long value) {
            addCriterion("agent_user_id like", value, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdNotLike(Long value) {
            addCriterion("agent_user_id not like", value, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdIn(List<Long> values) {
            addCriterion("agent_user_id in", values, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdNotIn(List<Long> values) {
            addCriterion("agent_user_id not in", values, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdBetween(Long value1, Long value2) {
            addCriterion("agent_user_id between", value1, value2, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andAgentUserIdNotBetween(Long value1, Long value2) {
            addCriterion("agent_user_id not between", value1, value2, "agentUserId");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("order_status is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("order_status is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(Integer value) {
            addCriterion("order_status =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(Integer value) {
            addCriterion("order_status <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(Integer value) {
            addCriterion("order_status >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_status >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(Integer value) {
            addCriterion("order_status <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(Integer value) {
            addCriterion("order_status <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLike(Integer value) {
            addCriterion("order_status like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotLike(Integer value) {
            addCriterion("order_status not like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<Integer> values) {
            addCriterion("order_status in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<Integer> values) {
            addCriterion("order_status not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(Integer value1, Integer value2) {
            addCriterion("order_status between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("order_status not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNull() {
            addCriterion("brand_id is null");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNotNull() {
            addCriterion("brand_id is not null");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualTo(Long value) {
            addCriterion("brand_id =", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualTo(Long value) {
            addCriterion("brand_id <>", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThan(Long value) {
            addCriterion("brand_id >", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualTo(Long value) {
            addCriterion("brand_id >=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThan(Long value) {
            addCriterion("brand_id <", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualTo(Long value) {
            addCriterion("brand_id <=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLike(Long value) {
            addCriterion("brand_id like", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotLike(Long value) {
            addCriterion("brand_id not like", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdIn(List<Long> values) {
            addCriterion("brand_id in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotIn(List<Long> values) {
            addCriterion("brand_id not in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdBetween(Long value1, Long value2) {
            addCriterion("brand_id between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotBetween(Long value1, Long value2) {
            addCriterion("brand_id not between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdIsNull() {
            addCriterion("other_brand_id is null");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdIsNotNull() {
            addCriterion("other_brand_id is not null");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdEqualTo(Long value) {
            addCriterion("other_brand_id =", value, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdNotEqualTo(Long value) {
            addCriterion("other_brand_id <>", value, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdGreaterThan(Long value) {
            addCriterion("other_brand_id >", value, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdGreaterThanOrEqualTo(Long value) {
            addCriterion("other_brand_id >=", value, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdLessThan(Long value) {
            addCriterion("other_brand_id <", value, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdLessThanOrEqualTo(Long value) {
            addCriterion("other_brand_id <=", value, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdLike(Long value) {
            addCriterion("other_brand_id like", value, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdNotLike(Long value) {
            addCriterion("other_brand_id not like", value, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdIn(List<Long> values) {
            addCriterion("other_brand_id in", values, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdNotIn(List<Long> values) {
            addCriterion("other_brand_id not in", values, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdBetween(Long value1, Long value2) {
            addCriterion("other_brand_id between", value1, value2, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andOtherBrandIdNotBetween(Long value1, Long value2) {
            addCriterion("other_brand_id not between", value1, value2, "otherBrandId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdIsNull() {
            addCriterion("series_id is null");
            return (Criteria) this;
        }

        public Criteria andSeriesIdIsNotNull() {
            addCriterion("series_id is not null");
            return (Criteria) this;
        }

        public Criteria andSeriesIdEqualTo(Long value) {
            addCriterion("series_id =", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdNotEqualTo(Long value) {
            addCriterion("series_id <>", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdGreaterThan(Long value) {
            addCriterion("series_id >", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdGreaterThanOrEqualTo(Long value) {
            addCriterion("series_id >=", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdLessThan(Long value) {
            addCriterion("series_id <", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdLessThanOrEqualTo(Long value) {
            addCriterion("series_id <=", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdLike(Long value) {
            addCriterion("series_id like", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdNotLike(Long value) {
            addCriterion("series_id not like", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdIn(List<Long> values) {
            addCriterion("series_id in", values, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdNotIn(List<Long> values) {
            addCriterion("series_id not in", values, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdBetween(Long value1, Long value2) {
            addCriterion("series_id between", value1, value2, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdNotBetween(Long value1, Long value2) {
            addCriterion("series_id not between", value1, value2, "seriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdIsNull() {
            addCriterion("other_series_id is null");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdIsNotNull() {
            addCriterion("other_series_id is not null");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdEqualTo(Long value) {
            addCriterion("other_series_id =", value, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdNotEqualTo(Long value) {
            addCriterion("other_series_id <>", value, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdGreaterThan(Long value) {
            addCriterion("other_series_id >", value, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdGreaterThanOrEqualTo(Long value) {
            addCriterion("other_series_id >=", value, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdLessThan(Long value) {
            addCriterion("other_series_id <", value, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdLessThanOrEqualTo(Long value) {
            addCriterion("other_series_id <=", value, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdLike(Long value) {
            addCriterion("other_series_id like", value, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdNotLike(Long value) {
            addCriterion("other_series_id not like", value, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdIn(List<Long> values) {
            addCriterion("other_series_id in", values, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdNotIn(List<Long> values) {
            addCriterion("other_series_id not in", values, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdBetween(Long value1, Long value2) {
            addCriterion("other_series_id between", value1, value2, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andOtherSeriesIdNotBetween(Long value1, Long value2) {
            addCriterion("other_series_id not between", value1, value2, "otherSeriesId");
            return (Criteria) this;
        }

        public Criteria andModelIdIsNull() {
            addCriterion("model_id is null");
            return (Criteria) this;
        }

        public Criteria andModelIdIsNotNull() {
            addCriterion("model_id is not null");
            return (Criteria) this;
        }

        public Criteria andModelIdEqualTo(Long value) {
            addCriterion("model_id =", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdNotEqualTo(Long value) {
            addCriterion("model_id <>", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdGreaterThan(Long value) {
            addCriterion("model_id >", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdGreaterThanOrEqualTo(Long value) {
            addCriterion("model_id >=", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdLessThan(Long value) {
            addCriterion("model_id <", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdLessThanOrEqualTo(Long value) {
            addCriterion("model_id <=", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdLike(Long value) {
            addCriterion("model_id like", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdNotLike(Long value) {
            addCriterion("model_id not like", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdIn(List<Long> values) {
            addCriterion("model_id in", values, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdNotIn(List<Long> values) {
            addCriterion("model_id not in", values, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdBetween(Long value1, Long value2) {
            addCriterion("model_id between", value1, value2, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdNotBetween(Long value1, Long value2) {
            addCriterion("model_id not between", value1, value2, "modelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdIsNull() {
            addCriterion("other_model_id is null");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdIsNotNull() {
            addCriterion("other_model_id is not null");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdEqualTo(Long value) {
            addCriterion("other_model_id =", value, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdNotEqualTo(Long value) {
            addCriterion("other_model_id <>", value, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdGreaterThan(Long value) {
            addCriterion("other_model_id >", value, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdGreaterThanOrEqualTo(Long value) {
            addCriterion("other_model_id >=", value, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdLessThan(Long value) {
            addCriterion("other_model_id <", value, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdLessThanOrEqualTo(Long value) {
            addCriterion("other_model_id <=", value, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdLike(Long value) {
            addCriterion("other_model_id like", value, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdNotLike(Long value) {
            addCriterion("other_model_id not like", value, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdIn(List<Long> values) {
            addCriterion("other_model_id in", values, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdNotIn(List<Long> values) {
            addCriterion("other_model_id not in", values, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdBetween(Long value1, Long value2) {
            addCriterion("other_model_id between", value1, value2, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andOtherModelIdNotBetween(Long value1, Long value2) {
            addCriterion("other_model_id not between", value1, value2, "otherModelId");
            return (Criteria) this;
        }

        public Criteria andActivityIdIsNull() {
            addCriterion("activity_id is null");
            return (Criteria) this;
        }

        public Criteria andActivityIdIsNotNull() {
            addCriterion("activity_id is not null");
            return (Criteria) this;
        }

        public Criteria andActivityIdEqualTo(Long value) {
            addCriterion("activity_id =", value, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdNotEqualTo(Long value) {
            addCriterion("activity_id <>", value, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdGreaterThan(Long value) {
            addCriterion("activity_id >", value, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdGreaterThanOrEqualTo(Long value) {
            addCriterion("activity_id >=", value, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdLessThan(Long value) {
            addCriterion("activity_id <", value, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdLessThanOrEqualTo(Long value) {
            addCriterion("activity_id <=", value, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdLike(Long value) {
            addCriterion("activity_id like", value, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdNotLike(Long value) {
            addCriterion("activity_id not like", value, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdIn(List<Long> values) {
            addCriterion("activity_id in", values, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdNotIn(List<Long> values) {
            addCriterion("activity_id not in", values, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdBetween(Long value1, Long value2) {
            addCriterion("activity_id between", value1, value2, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityIdNotBetween(Long value1, Long value2) {
            addCriterion("activity_id not between", value1, value2, "activityId");
            return (Criteria) this;
        }

        public Criteria andActivityNameIsNull() {
            addCriterion("activity_name is null");
            return (Criteria) this;
        }

        public Criteria andActivityNameIsNotNull() {
            addCriterion("activity_name is not null");
            return (Criteria) this;
        }

        public Criteria andActivityNameEqualTo(String value) {
            addCriterion("activity_name =", value, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameNotEqualTo(String value) {
            addCriterion("activity_name <>", value, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameGreaterThan(String value) {
            addCriterion("activity_name >", value, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameGreaterThanOrEqualTo(String value) {
            addCriterion("activity_name >=", value, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameLessThan(String value) {
            addCriterion("activity_name <", value, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameLessThanOrEqualTo(String value) {
            addCriterion("activity_name <=", value, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameLike(String value) {
            addCriterion("activity_name like", value, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameNotLike(String value) {
            addCriterion("activity_name not like", value, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameIn(List<String> values) {
            addCriterion("activity_name in", values, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameNotIn(List<String> values) {
            addCriterion("activity_name not in", values, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameBetween(String value1, String value2) {
            addCriterion("activity_name between", value1, value2, "activityName");
            return (Criteria) this;
        }

        public Criteria andActivityNameNotBetween(String value1, String value2) {
            addCriterion("activity_name not between", value1, value2, "activityName");
            return (Criteria) this;
        }

        public Criteria andStandardIsNull() {
            addCriterion("standard is null");
            return (Criteria) this;
        }

        public Criteria andStandardIsNotNull() {
            addCriterion("standard is not null");
            return (Criteria) this;
        }

        public Criteria andStandardEqualTo(Integer value) {
            addCriterion("standard =", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotEqualTo(Integer value) {
            addCriterion("standard <>", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardGreaterThan(Integer value) {
            addCriterion("standard >", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardGreaterThanOrEqualTo(Integer value) {
            addCriterion("standard >=", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLessThan(Integer value) {
            addCriterion("standard <", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLessThanOrEqualTo(Integer value) {
            addCriterion("standard <=", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLike(Integer value) {
            addCriterion("standard like", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotLike(Integer value) {
            addCriterion("standard not like", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardIn(List<Integer> values) {
            addCriterion("standard in", values, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotIn(List<Integer> values) {
            addCriterion("standard not in", values, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardBetween(Integer value1, Integer value2) {
            addCriterion("standard between", value1, value2, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotBetween(Integer value1, Integer value2) {
            addCriterion("standard not between", value1, value2, "standard");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCookieIsNull() {
            addCriterion("cookie is null");
            return (Criteria) this;
        }

        public Criteria andCookieIsNotNull() {
            addCriterion("cookie is not null");
            return (Criteria) this;
        }

        public Criteria andCookieEqualTo(String value) {
            addCriterion("cookie =", value, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieNotEqualTo(String value) {
            addCriterion("cookie <>", value, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieGreaterThan(String value) {
            addCriterion("cookie >", value, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieGreaterThanOrEqualTo(String value) {
            addCriterion("cookie >=", value, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieLessThan(String value) {
            addCriterion("cookie <", value, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieLessThanOrEqualTo(String value) {
            addCriterion("cookie <=", value, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieLike(String value) {
            addCriterion("cookie like", value, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieNotLike(String value) {
            addCriterion("cookie not like", value, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieIn(List<String> values) {
            addCriterion("cookie in", values, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieNotIn(List<String> values) {
            addCriterion("cookie not in", values, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieBetween(String value1, String value2) {
            addCriterion("cookie between", value1, value2, "cookie");
            return (Criteria) this;
        }

        public Criteria andCookieNotBetween(String value1, String value2) {
            addCriterion("cookie not between", value1, value2, "cookie");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table mhc_clue
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class corresponds to the database table mhc_clue
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}